Relatamail Data Dictionary
Field |
Type |
Null |
MsgOwner |
Int(11) |
No |
MsgNumber |
Int(11) |
No |
RecipientCount |
bigint(20) |
No |
EmailFrom |
varchar(80) |
No |
NameFrom |
varchar(80) |
No |
MsgSubject |
longtext |
No |
MsgDescription |
longtext |
No |
DestinationSite |
varchar(80) |
No |
RedirectURL |
longtext |
No |
AOLRedirectURL |
longtext |
No |
UnsubscribeURL |
longtext |
No |
AOLUnsubscribeURL |
longtext |
No |
UnsubscribePrompt |
longtext |
No |
AOLAware |
enum('0','1') |
No |
AppendVar |
longtext |
No |
MsgTemplate |
longtext |
No |
SendOutBeganAt |
datetime |
No |
SendOutCompletedAt |
datetime |
No |
SendOutCancelled |
enum('0','1') |
No |
Keyname |
Unique |
Field |
PRIMARY |
Yes |
MsgOwner |
PRIMARY |
Yes |
MsgNumber |
Fields:
Data Type:
IntegerDefinition: the owner of the message being sent.
Example: 1
Properties: numeric, size: 11
Entered By: system
Type of Key: primary
Required: yes
Data Type:
IntegerDefinition: the number of the message being sent.
Properties:
numeric, size: 11Entered By: system
Type of Key: primary
Required: yes
Data Type:
Big IntegerDefinition: the number of recipients the message is being sent to.
Properties:
numeric, size: 20Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: the senders email address
Properties:
Alphanumeric, size: 80Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: the senders email address
Properties:
Alphanumeric, size: 80Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: the subject of the email
Properties:
Alphanumeric, size: 4.3 billionEntered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: description of the message being sent
Properties:
Alphanumeric, size: 4.3 billionEntered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: the destination URL the receiver can click on.
Properties:
Alphanumeric, size: 80Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: the URL where the user will be redirected to when the destination site has been contacted.
Properties:
Alphanumeric, size: 4.3 billionEntered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: the URL where AOL users will be redirected to when the destination site has been contacted.
Properties:
Alphanumeric, size: 4.3 billionEntered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: the URL the receiver can click on to unsubscribe from a list.
Properties:
Alphanumeric, size: 4.3 billionEntered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: the URL an AOL user can click on to unsubscribe from a list.
Properties:
Alphanumeric, size: 4.3 billionEntered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: the message sent to the user when unsubscribing from a list.
Properties:
Alphanumeric, size: 4.3 billionEntered By: system
Type of Key: non-primary
Required: yes
Data Type:
BooleanDefinition: select 1 if sending out to AOL users.
Properties:
Enumeration, size: 1; 0 or 1Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: a variable to append to the end of an URL
Properties:
Alphanumeric, size: 4.3 billionEntered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: the core body of the message
Properties:
Alphanumeric, size: 4.3 billionEntered By: system
Type of Key: non-primary
Required: yes
Data Type:
datetimeDefinition: the date and time the sent out began at
Properties:
Datetime, size: defaultEntered By: system
Type of Key: non-primary
Required: yes
Data Type:
datetimeDefinition: the date and time the send out completed
Properties:
Datetime, size: defaultEntered By: system
Type of Key: non-primary
Required: yes
19. SendOutCancelled
Data Type:
BooleanDefinition: whether the send out was cancelled.
Properties:
Alphanumeric, size: 80Entered By: system
Type of Key: non-primary
Required: yes
Table: Contact The table ‘Contact’ records information about each contact person.
Field |
Type |
Null |
|||
|
Varchar(80) |
No |
|||
First_Name |
Varchar(40) |
No |
|||
Last_Name |
Varchar(40) |
No |
|||
Address |
Varchar(60) |
No |
|||
City |
Varchar(40) |
No |
|||
State |
varchar(20) |
No |
|||
Zip |
varchar(20) |
No |
|||
Country |
varchar(40) |
No |
|||
Phone1 |
varchar(30) |
No |
|||
Phone2 |
varchar(30) |
No |
|||
Fax |
varchar(30) |
No |
|||
Language |
varchar(30) |
No |
|||
Birthdate |
varchar(20) |
No |
|||
Sex |
char(1) |
No |
|||
Married |
char(1) |
No |
|||
Employed |
char(1) |
No |
|||
Email_Type |
char(1) |
No |
|||
Entry_Date |
date |
No |
|||
Undeliverable_Count |
int(11) |
No |
|||
Keyname |
Unique |
Field |
|||
PRIMARY |
Yes |
|
|||
|
No |
|
Data Type:
AlphanumericDefinition: the unique email address of the person. Each person has an unique email address that is uniquely theirs, it identifies them.
Example: avinesh@stratabase.com
Properties: alphanumeric, size: 80
Entered By: user
Type of Key: primary
Required: yes
Data Type:
AlphanumericDefinition: the first name of the person
Example: Avinesh
Properties: Alphanumeric, size: 40
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the last name of the person
Example: Bangar
Properties: Alphanumeric, size: 40
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the street address where the person lives
Example: 12345 Any Street
Properties: Alphanumeric, size: 60
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the city where the person lives
Example: Abbotsford
Properties: Alphanumeric, size: 40
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the state or province where the person lives
Example: Avinesh
Properties: Alphanumeric, size: 20
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the zip or postal code where the person lives first name of the person
Example: 12345
Properties: Alphanumeric, size: 20
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the country where the person lives
Example: CANADA
Properties: Alphanumeric, size: 40
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the primary phone number of the person
Example: 123-4567
Properties: Alphanumeric, size: 30
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the secondary phone number of the person
Example: 123-4567
Properties: Alphanumeric, size: 30
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the fax number of the person
Example: 123-4567
Properties: Alphanumeric, size: 30
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the preferred language of the person
Example: English
Properties: Alphanumeric, size: 30
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the birthdate of the person
Example: 01-01-01
Properties: Alphanumeric, size: 20
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphaDefinition: person is either male (M) or female (F)
Example: M
Properties: Alpha, size: 1
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphaDefinition: person is either single (S) or married (M)
Example: S
Properties: Alpha, size: 1
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphaDefinition: person is either employed (E) or unemployed (U) or retired (R)
Example: E
Properties: Alpha, size: 1
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphaDefinition: the email type used by the person – either HTML or Text
Example: H (H or T)
Properties: Alpha, size: 1
Entered By: system
Type of Key: non-primary
Required: no
Data Type:
Numeric (Date)Definition: the date the person was first entered into our database
Example: MM/DD/YYYY
Properties: Numeric, size: 10
Entered By: system
Type of Key: non-primary
Required: no
Data Type:
NumericDefinition: the number of times an undeliverable email was sent to this person
Example: 2
Properties: Numeric, size: 1
Entered By: system
Type of Key: non-primary
Required: no
Field |
Type |
Null |
||
|
varchar(80) |
No |
||
List_Number |
int(10) |
No |
||
Subscribe_Date |
date |
Yes |
||
Unsubscribe_Date |
date |
Yes |
||
Keyname |
Unique |
Field |
||
PRIMARY |
Yes |
|
||
PRIMARY |
Yes |
List_Number |
Fields:
Data Type:
AlphanumericDefinition: the email address of the person
Example: avinesh@stratabase.com
Properties: Alphanumeric, size: 80
Entered By: user
Type of Key: primary
Required: yes
Data Type:
NumericDefinition: the list number the person is subscribed to
Example: 1
Properties: numeric, size: 10
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
Date format (numeric)Definition: the date the person signed up (subscribed) to the list they are subscribed to
Example: MM/DD/YYYY
Properties: numeric, size: 20
Entered By: system
Type of Key: non-primary
Required: no
Data Type:
Date format (numeric)Definition: the date the person unsubscribed from the list they originally subscribed to.
Example: MM/DD/YYYY
Properties: numeric, size: 20
Entered By: system
Type of Key: non-primary
Required: no
Field |
Type |
Null |
Default |
|
varchar(80) |
No |
|
Message_Number |
int(10) |
No |
0 |
TimeDate_Sent |
datetime |
No |
0000-00-00 00:00:00 |
TimeDate_Click |
datetime |
No |
0000-00-00 00:00:00 |
TimeDate_Undeliverable |
datetime |
No |
0000-00-00 00:00:00 |
DestinationURL |
varchar(80) |
No |
|
AppendVar |
varchar(80) |
No |
n |
Keyname |
Unique |
Field |
PRIMARY |
Yes |
|
PRIMARY |
Yes |
Message_Number |
PRIMARY |
Yes |
|
Fields:
Data Type:
AlphanumericDefinition: email address of the receiver
Example: avinesh@stratabase.com
Properties: Alphanumeric, size: 80
Entered By: system
Type of Key: primary
Required: yes
Data Type:
NumericDefinition: message number
Example: 1
Properties: numeric, size: 10
Entered By: system
Type of Key: primary
Required: no
Data Type:
Date format (numeric)Definition: the date the person sent the message
Example: MM/DD/YYYY 00:00:00
Properties: numeric, size: 20
Entered By: system
Type of Key: non-primary
Required: no
Data Type:
Date format (numeric)Definition: the date the
Example: MM/DD/YYYY 00:00:00
Properties: numeric, size: 20
Entered By: system
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the URL the receiver of the email clicked on
Example: http://www.myhost.com/mypage.htm?user=bob&id=1234
Properties: numeric, size: 80
Entered By: system
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the variable name appended to the end of the URL string
Example: ?email=user@host.com
Properties: alphanumeric, size: 80
Entered By: user
Type of Key: non-primary
Required: no
Field |
Type |
Attributes |
Null |
Default |
Number |
int(10) |
|
No |
0 |
Name |
Varchar(40) |
|
No |
|
Description |
Varchar(200) |
|
No |
|
Source |
Varchar(100) |
|
No |
|
Owner |
int(11) |
|
No |
|
Keyname |
Unique |
Field |
PRIMARY |
Yes |
Number |
Fields
:Data Type:
NumericDefinition: the number we have assigned to the list which people subscribe to, the list number is the unique code we use to describe the individual list.
Example: 1
Properties: numeric, size: 10
Entered By: system
Type of Key: primary
Required: yes
Data Type:
AlphanumericDefinition: the name of the list that people have subscribed to
Example: Bob’s List
Properties: Alphanumeric, size: 10
Entered By: user
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: descriptive phrase that tells which subject matter the list covers
Example: Bob’s List
Properties: Alphanumeric, size: 200
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: a short description of the list owner
Example: John Smith
Properties: Alphanumeric, size: 100
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
NumericDefinition: the number of the owner of the list, cross-references with RM_User::UserNumber
Example: 1001
Properties: numeric, size: 11
Entered By: system
Type of Key: non-primary
Required: no
Field |
Type |
Attributes |
Null |
Default |
Number |
int(10) |
|
No |
0 |
Description |
varchar(200) |
|
No |
|
DateSent |
date |
|
No |
|
List_Number |
int(11) |
|
No |
0 |
Msg_Type |
enum(‘test’, blast’) |
|
No |
test |
Keyname |
Unique |
Field |
PRIMARY |
Yes |
Number |
PRIMARY |
Yes |
List_Number |
Fields:
Data Type:
NumericDefinition: the number we assign through our system to the message which gets sent to the subscriber.
Example: 1001
Properties: Numeric, size: 10
Entered By: system
Type of Key: primary
Required: yes
Data Type:
AlphanumericDefinition: the description of the message sent to the recipients, inputted by the sender to describe its contents.
Example: A test email
Properties: Alphanumeric, size: 200
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
DateDefinition: the date the message was sent
Example: 2001-01-01
Properties: Date, size: 10
Entered By: system
Type of Key: non-primary
Required: no
Data Type:
NumericDefinition: the list the message was sent out to
Example: 101
Properties: Numeric, size: 11
Entered By: system
Type of Key: non-primary
Required: no
Data Type:
BooleanDefinition: the type of message being sent, either test or blast
Example: blast
Properties: Enum, size: 5
Entered By: user
Type of Key: non-primary
Required: no
Field |
Type |
Null |
Default |
|
varchar(80) |
No |
|
First_Name |
varchar(80) |
No |
|
Last_Name |
varchar(80) |
No |
|
TimeDate_Register |
datetime |
No |
0000-00-00 00:00:00 |
Login |
varchar(80) |
No |
|
Password |
varchar(80) |
No |
|
User_Number |
int(11) |
No |
0 |
DateTime_Login |
datetime |
No |
0000-00-00 00:00:00 |
DateTime_Logout |
datetime |
No |
0000-00-00 00:00:00 |
IP |
varchar(80) |
No |
|
Session_Key |
varchar(80) |
No |
|
RM_Access |
enum('1','0') |
No |
1 |
UserID |
Longtext |
No |
Keyname |
Unique |
Field |
Action |
PRIMARY |
Yes |
|
Drop |
Fields:
Data Type:
AlphanumericDefinition: email address of the user
Example: ravi@stratabase.com
Properties: alphanumeric, size: 80
Entered By: user
Type of Key: primary
Required: yes
Data Type:
AlphanumericDefinition: this is the first name of the user
Example: Ravi
Properties: alphanumeric, size: 80
Entered By: user
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: this is the last name of the user
Example: Gill
Properties: alphanumeric, size: 80
Entered By: user
Type of Key: non-primary
Required: yes
Data Type:
DateDefinition: this is the time and date the user registered
Example: 2000-01-01 00:00:00
Properties: Numeric, size: 12
Entered By: user
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: this is the login of the user
Example: Bob2000
Properties: Alphanumeric, size: 80
Entered By: user
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: this is the password of the user
Example: R3latama1l
Properties: alphanumeric, size: 80
Entered By: user
Type of Key: non-primary
Required: yes
Data Type:
NumericDefinition: this is the user number of the user
Example: 1
Properties: alphanumeric, size: 11
Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
DateDefinition: the date and time a user logged in into the Relatamail system
Example: 2000-01-01 00:00:00
Properties: Numeric, size: 12
Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
DateDefinition: this is when the user logged out from the Relatamail system
Example: 2000-01-01 00:00:04
Properties: Numeric, size: 12
Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: this is the Internet Protocol (IP) address of the user
Example: 123.456.789.100
Properties: Alphanumeric, size: 80
Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
AlphanumericDefinition: this is the session key of the user, dynamic
Example: f1f2f3f4g5f65f6f7f8f8f9f0
Properties: Alphanumeric, size: 80
Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
NumericDefinition: determines if the user has permission to use the Relatamail system
Example: 1
Properties: enum, size: 1
Entered By: system
Type of Key: non-primary
Required: yes
Data Type:
LongtextDefinition: the user ID of the current user, dynamic
Example: s42f82f28f208f10f1
Properties: longtext, size: ~4.3 billion
Entered By: system
Type of Key: non-primary
Required: yes
Field |
Type |
Null |
Name |
Varchar(80) |
No |
Value |
Longtext |
No |
Keyname |
Unique |
Field |
PRIMARY |
Yes |
Name |
Fields
:Data type:
AlphanumericDefinition: the name of the variable
Example: Email
Properties: Alphanumeric, size: 80
Entered By: system
Type of Key: primary
Required: yes
Data type:
AlphanumericDefinition: the value of the variable
Example: user@host.com
Properties:
Alphanumeric, size: 80Entered By: system
Type of Key: primary
Required: yes
Field |
Type |
Null |
|||
|
varchar(80) |
No |
|||
First_Name |
varchar(40) |
No |
|||
Last_Name |
varchar(40) |
No |
|||
Address |
varchar(60) |
No |
|||
City |
varchar(40) |
No |
|||
State |
varchar(20) |
No |
|||
Zip |
varchar(20) |
No |
|||
Country |
varchar(40) |
No |
|||
Phone1 |
varchar(30) |
No |
|||
Phone2 |
varchar(30) |
No |
|||
Fax |
varchar(30) |
No |
|||
Language |
varchar(30) |
No |
|||
Birthdate |
varchar(20) |
No |
|||
Sex |
char(1) |
No |
|||
Married |
char(1) |
No |
|||
Employed |
char(1) |
No |
|||
Email_Type |
char(1) |
No |
|||
Entry_Date |
date |
No |
|||
Undeliverable_Count |
int(11) |
No |
|||
|
|||||
Keyname |
Unique |
Field |
|||
PRIMARY |
Yes |
|
|||
|
No |
|
Fields:
Data Type:
AlphanumericDefinition: the unique email address of the person. Each person has an unique email address that is uniquely theirs, it identifies them.
Example: avinesh@stratabase.com
Properties: alphanumeric, size: 80
Entered By: user
Type of Key: primary
Required: yes
Data Type:
AlphanumericDefinition: the first name of the person
Example: Avinesh
Properties: Alphanumeric, size: 40
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the last name of the person
Example: Bangar
Properties: Alphanumeric, size: 40
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the street address where the person lives
Example: 12345 Any Street
Properties: Alphanumeric, size: 60
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the city where the person lives
Example: Abbotsford
Properties: Alphanumeric, size: 40
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the state or province where the person lives
Example: Avinesh
Properties: Alphanumeric, size: 20
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the zip or postal code where the person lives first name of the person
Example: 12345
Properties: Alphanumeric, size: 20
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the country where the person lives
Example: CANADA
Properties: Alphanumeric, size: 40
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the primary phone number of the person
Example: 123-4567
Properties: Alphanumeric, size: 30
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the secondary phone number of the person
Example: 123-4567
Properties: Alphanumeric, size: 30
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the fax number of the person
Example: 123-4567
Properties: Alphanumeric, size: 30
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the preferred language of the person
Example: English
Properties: Alphanumeric, size: 30
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphanumericDefinition: the birthdate of the person
Example: 01-01-01
Properties: Alphanumeric, size: 20
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphaDefinition: person is either male (M) or female (F)
Example: M
Properties: Alpha, size: 1
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphaDefinition: person is either single (S) or married (M)
Example: S
Properties: Alpha, size: 1
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphaDefinition: person is either employed (E) or unemployed (U) or retired (R)
Example: E
Properties: Alpha, size: 1
Entered By: user
Type of Key: non-primary
Required: no
Data Type:
AlphaDefinition: the email type used by the person – either HTML or Text
Example: H (H or T)
Properties: Alpha, size: 1
Entered By: system
Type of Key: non-primary
Required: no
Data Type:
Numeric (Date)Definition: the date the person was first entered into our database
Example: MM/DD/YYYY
Properties: Numeric, size: 10
Entered By: system
Type of Key: non-primary
Required: no
Data Type:
NumericDefinition: the number of times an undeliverable email was sent to this person
Example: 2
Properties: Numeric, size: 1
Entered By: system
Type of Key: non-primary
Required: no